Excel 2010 For Comp Apps
Beginning Excel 2010 Skills
- 1.Which formula can add the all the numeric values in a range of cells?
- A.
Count
- B.
Average
- C.
Sum (Auto-sum)
- D.
Add
- 2.Is it possible to insert an image from a file into an Excel spreadsheet?
- A.
Yes
- B.
No
- 3.What name is given to the chart background?
- A.
Chart area
- B.
Background area
- C.
Legend area
- D.
Plot area
- 4.The Chart Tools commands are found in these three tabs?
- A.
Design, Shape, Layout
- B.
Layout, Format, Type
- C.
Design, Layout, Format
- D.
Styles, Shapes, Effects
- 5.What is a worksheet tab in Excel 2010?
- A.
A worksheet tab is used to access tools associated with the worksheet
- B.
A worksheet tab is used to move from one cell to the next cell in a worksheet
- C.
A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet
- D.
A worksheet tab is used to get help when working with Microsoft Excel 2010.
- 6.Once data is entered into a cell, can it be edited?
- A.
Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editing
- B.
No, data in a cell can only be changed by creating a copy of the original spreadsheet into a new spreadsheet
- C.
No, once a file is saved, cell data cannot be changed
- D.
Yes, but the file must be saved with a different file name
- 7.Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?
- A.
#
- B.
%
- C.
&
- D.
$
- 8.When number signs (#####) are displayed in the cell, it means:
- A.
The formula in the cell is wrong
- B.
There are too many characters in the cell to be displayed with the current cell width
- C.
The decimal point placement in the cell is wrong
- D.
All of the above
- 9.How do you select cells that are not next to each other? (Ex: As when you are selecting 2 columns of information to graph.)
- A.
Click the first cells, then hold down SHIFT on the keyboard and select the other cells
- B.
Click the first cells, then hold down ALT on the keyboard as you select the other cells
- C.
Click the first cells, hold down CTRL on the keyboard and then select the other cells
- D.
Click the first cells, then hold down SHIFT as you move from cell to cell using the Arrow keys on the keyboard
- 10.Which function would you use to find the largest number in a selected range of cells?
- A.
MAXIMUM
- B.
MAX
- C.
LARGE
- D.
LARGEST
- 11.
According to the picture the selected cell in yellow corresponds to:- A.
Column A, Row A11, Cell 11
- B.
Column 11, Row A, Cell 11A
- C.
Column 11, Row A, Cell A11
- D.
Column A, Row 11, Cell A11
- 12.Inserting Page Number is in Header and Footer
- A.
True
- B.
False
- 13.If you wanted to subtract E2 from E1, how would that formula look?
- A.
=E1-E2
- B.
=E2-E1
- C.
E2-E1
- D.
None of the above
- 14.If you want to remove gridlines from the spreadsheet, which tab would you select?
- A.
File
- B.
Review
- C.
View
- D.
Formulas
- 15.You would use Excel to:
- A.
Make a web page.
- B.
Write a letter
- C.
Create a poster
- D.
Record numerical data
- 16.Which version of Microsoft Excel are we using in class?
- A.
2007
- B.
2010
- C.
2011
- D.
XP
- 17.When you filter something in Excel, you are.......
- A.
Sorting it from highest to lowest
- B.
Finding the items that meet the criteria you indicated
- C.
Creating a filtering diagram.
- D.
Removing the items from their original place in the spreadsheet.
- 18.In Microsoft Excel you produce:
- A.
Spreadsheets and Workbooks
- B.
Documents
- C.
Slide Presentations
- D.
Heart Attacks and Kidney Disease
- 19.When Sorting in Excel, you need to:
- A.
Go to the Review tab.
- B.
Sort alphabetically first.
- C.
Just sort by the information in 1 columns.
- D.
Highlight all the information in the table of the spreadsheet (except for the total and average rows or columns of information)
- 20.The correct formula to find the average of cells A4 to C4 is:
- A.
=avg(A4:C4)
- B.
Average(A4:C4)
- C.
=average A4 to C4
- D.
=average(A4:C4)
- 21.To format the color or border of a cell, or the date or number inside the cell to a certain format, you should:
- A.
Do it in Word.
- B.
Click on the Review tab.
- C.
Right-click in the cell, and select Format Cells.
- D.
Click on the File tab.
- 22.To insert a picture as the background of a spreadsheet,
- A.
Go to Insert, then Picture.
- B.
Click on the Page Layout tab, then Background.
- C.
Copy and paste the image from the Internet.
- D.
Do a screenshot.
- 23.The file extension of a Word document is: .doc or .docx. The file extension of an Excel spreadsheet is:
- A.
.cels
- B.
.ppt or .pptx
- C.
.xls or .xlsx
- D.
None of the above
- 24.Which of the following would Excel be used for in a business:
- A.
Record Income and Expenses
- B.
Track Inventory
- C.
Payroll
- D.
All of the Above
- 25.Which one of the following best describes the Autofill feature?
- A.
Pressing a button to automatically fill in the missing pieces of an image.
- B.
Isolating certain pieces of information that meet the set requirements.
- C.
Automatically filling the object with color.
- D.
The black cross you get at the bottom right of the cell so you can copy the formula to other cells
Related Topics
Recent Quizzes
Back to top