Microsoft Excel Basics
Test your knowledge of basic Microsoft Excel features including charting, formatting, formulas, and printing options.
Questions
What displays the contents of the active cell?
- Namebox
- RowHeadings
- FormulaBar
- Taskpane
Which function calculates the largest value in a set of numbers?
- Average
- Count
- Min
- Max
Which button on the standard toolbar gives you quick access to the Sum, Average, Count, Min, and Max functions?
- Autosum
- Insert
- AutoFill
- Paste
Which style button adds the dollar signs and commas to values?
- Comma
- Currency
- Percent
- AdjustDecimal
What gives you the convenience of the Formatting toolbar's one click access to many formatting tasks?
- FormatBox
- CellBox
- DialogBox
- NameBox
A fast way to add up this column of numbers is to click in the cell below the numbers and then:
- Click Subtotals on the Data menu.
- View the sum in the formula bar.
- Click the AutoSum button Button image on the Standard toolbar, then press ENTER.
- Noneofthese
Suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page?
- Click Page Setup on the File menu, click the Sheet tab, and enter the row that contains these column headings under Print titles.
- Click Page Setup on the File menu, click the Page tab, click the Options button, then enter your choices.
- Click Page Setup on the File menu, click the Sheet tab, and make a selection under the Print heading.
- Noneofthese
How should you print a selected area of a worksheet, if you'll want to print a different area next time?
- On the File menu, point to Print Area, and then click Set Print Area.
- On the File menu, click Print, and then click Selection under Print what.
- On the View menu, click Custom Views, then click Add.
- Noneofthese
What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20?
- elect both cells, and then drag the fill handle Fill handle over the range you want, for instance 18 more rows
- Select the range you want, including both cells, point to Fill on the Edit menu, and then click Down.
- Copy the second cell, click in the cell below it, on the Standard toolbar click the down arrow on the Paste Button image button, and then click Paste Special.
- Noneofthese
What do you use to create a chart?
- ChatWizard
- PieWizard
- ExcellWizard
- DataWizard
Which type of chart shows the pattern or relationships between sets of data points?
- Line
- Pie
- Area
- XL
True or False, You can modify an exisiting chart?
- True
- False
Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
- Use CTRL to select all three cells, then click the Paste Button image button on the Standard toolbar.
- Copy the selected cell, then select the other two cells, click Style on the Format menu, then click Modify.
- Click Format Painter Button image on the Formatting toolbar twice, then click in each cell you want to copy the formatting to.
- Noneofthese
To balance your checkbook in Excel, your best method is:
- Copy your check amounts into Excel so that you'll have a neat printout to work on.
- Use Excel to check your arithmetic.
- Download the Checkbook Register template from Templates on Microsoft Office Online.
- Noneofthese