Computer Test Questions
Q. You can open the Sort dialog box by choosing Sort from the ___menu
a. View
b. Format
c. Tools
d. Data✅
Q. when working in the page break preview, you can
a. view exactly where each page break occurs
b. add or remove page breaks
c. change the print area
d. all of above✅
Q. A data map is helpful
a. When you have too much data to chart
b. To show a geographic distribution of data✅
c. To compare data points
d. To show changes in data over time
Q. Which of the following shortcut key is used to Minimize current window of excel.
a. Ctrl+F9✅
b. Shift+F9
C. Alt+F9
d. none of these
Q. You can copy data or formulas
a. With the copy, paste and cut commands on the edit menu
b. With commands on a shortcut menu
c. With buttons on the standard toolbar
d. All of the above✅
Q. You can activate a cell by
a. Pressing the Tab key
b. Clicking the cell
c. Pressing an arrow key
d. All of above✅
Q. Which of the following setup options can not be set in the page setup dialog box?
a. Printer selection✅
b. Vertical or horizontal placement
c. Orientation
d. Row and column titles
Q. What term refers to a specific set of values saved with the workbook?
a. Range
b. Scenario✅
C. Trend line
d. What if analysis.
Q. Got functions? No? You need the insert function dialog box. How do you get it?
a. Right click a cell and then click insert
b. Click the insert menu and then click function✅
c. Type = in a cell
d. All of the above
Q. Which of the following describes how to select all the cells in a single column?
a. Right click on column and select Pick from list
b. Use data - text to columns menu item
c. Left click on the gray column title buttan✅
d. Pressing Ctrl A on the keyboard
Q. when you use the fill effects in the format data series dialog box, you can not
a. rotate text on the chart✅
b. select a fore ground color
c. select a pattern
d. select a background color.
Q. Paper spreadsheets can have all the same advantages as an electronic spreadsheet except 5 which of the following?
a. Rows and columns
b. Headings
c. Speed✅
d. None
Q. Which of the following shortcut key is used to Maximize currently selected window of excel.
a. Ctrl»F10✅
b. Shift F10
C. Alt F10
d. none of these
Q. What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20?
a. Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows✅
b. Select the range you want, include both cells, point to fill on the Edit menu, and then click down.
c. Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special
d. All of above
Q. If you changed the color of text in another cell, which of the following shortcut key will change the text in cell to the same color.
a. F1
b. F2
c. F3
d. F4✅
Q. What Pivot Table toolbar button updates the data in a Pivot Table o: Pivot Chart report if the source data has changed
a. Format Report
b. Pivot Table
c. Refresh Data✅
d. Show Detail
Q. What is an expression that tells how the numbers in a determined set of cells are to be calculated?
a. Formula✅
b. Field
c. Data
d Query
Q. "Qtr 1, Qtr 2, Qtr 3" is an example of a
a. Formula
b. Function
c. Series✅
d. Syntax
Q. You can edit existing Excel data by pressing the
a. F1 key
b. F2 key✅
c. F3 key
d. F4 key
Q. The cell reference for a range of cells that starts in cell 81 and goes over to column G and down to row 10 is ___
a. G1-G10
b. B1.G10
c. 81,G10
d. B1.G10✅
Q. A user wishes to remove a spreadsheet from a workbook Which is the correct sequence of events that will do this?
a. Go to File-Save As Save As Type worksheet
b. Right click on the spreadsheet tab and select Excel DELETE✅
c. Right click on the spreadsheet and select Insert- Entire Column
d. None of above
Q. What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?
a. Goal Seek
b. Scenario Summary report
c. Forecasting
d. Trend line✅
Q. what term describes a background that appears as a grainy, non smooth surface
a. gradient✅
b. pattern
c. solid
d. texture
Q. Excel is a
a. Graphic program
b. None of these
c. Word processor
d. A spreadsheet✅
Q. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called
a. HTML
b. Pivot Table Field List
c. Pivat Table List
d. Pivot Table Report✅
Q. Which of the following is not a valid Zoom percentage in Excel?
a. 10
b. 100
c. 300
d. 500✅
Q. The spelling tool is placed on____toolbar.
a. Standard✅
b. Formatting
c. Drawing
d. Reviewing
Q. To select all of the boxes of an organization chart
a. Clicking and edit and select all
b. Right click the chart background and then click select all
c. Press and hold the SHIFT key and click each box
d. All of above✅
Q. You can show the shartcut menu during the slide show by
a. Clicking the shortcut button on the formatting toolbar.
b. Right clicking the curren slide✅
c. Clicking an icon on the current slide
d. a and b
Q. Auto clipart is a feature that
a. Automatically places clipart in your presentation
b. Scans your presentation for incorrect spelling in your words on each slide
c. Scans your presentation for incorrect spelling in Word Arts objects
d. All of above✅
Q. To edit the text within the boxes of an organization chart, you
a. select the box and text, then make changes✅
b. select the box, then make the changes
c. highlight the text, them make the changes
d. and b both
Q. Which of the follawing allow you to select more than one slide in a presentation?
a. Alt + Click each slide b. Shift+Click each slide
c. both A&B✅
d. Ctrl + Click each slide
Q. The view that displays the slides on a presentation as miniature representations of the sides is called
a slide show
b. slide sorter view✅
C. notes page view
d. outline view
Q. The PowerPolnt view that displays only text (title and bullets) is
a. Slide show
b. Slide sorter view
c. Notes page view
d. Outline view✅
Q. In Microsoft PowerPoint the entry effect as one slide replaces another in a show is called a (an)
a. animation
b. slide transition✅
C. Custom animation
d. preset animatian
Q. Which of the following presentation elements can you modily using the slide master?
a. Slide comments
b. Slide transitions✅
c. Speaker note font and color
d. All of above
Q. Which of the following provides a printed copy of your presentation?
a. Outline
b. Speaker notes
C. Audience handouts✅
d. All of the above
Q. Slide show options avallable to the presenter Include all of the following except
a. Transitions command✅
b. Speaker notes command
C. Meeting reminder command
d. Navigation commands
Q. Presentation designs regulate the formatting and layout for the slide and are commonly called
a. Design plates
b. Templates✅
c. Placeholders
d. Blueprints
Q. Which of the following bypasses the print dialog box when printing individual slides or an entire presentation?
a File, print, preview
b. The print button✅
c. File, print
d. Ctrl+P
Q. To add a header or footer to your handout, you can use
a. The title master
b. The slide mast-r
c. The handout master✅
d. All of above
Post a Comment