Beginning Excel 2010 Skills
Count
Average
Sum (Auto-sum)
Add
Yes
No
Chart area
Background area
Legend area
Plot area
Design, Shape, Layout
Layout, Format, Type
Design, Layout, Format
Styles, Shapes, Effects
A worksheet tab is used to access tools associated with the worksheet
A worksheet tab is used to move from one cell to the next cell in a worksheet
A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet
A worksheet tab is used to get help when working with Microsoft Excel 2010.
Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editing
No, data in a cell can only be changed by creating a copy of the original spreadsheet into a new spreadsheet
No, once a file is saved, cell data cannot be changed
Yes, but the file must be saved with a different file name
#
%
&
$
The formula in the cell is wrong
There are too many characters in the cell to be displayed with the current cell width
The decimal point placement in the cell is wrong
All of the above
Click the first cells, then hold down SHIFT on the keyboard and select the other cells
Click the first cells, then hold down ALT on the keyboard as you select the other cells
Click the first cells, hold down CTRL on the keyboard and then select the other cells
Click the first cells, then hold down SHIFT as you move from cell to cell using the Arrow keys on the keyboard
MAXIMUM
MAX
LARGE
LARGEST
Column A, Row A11, Cell 11
Column 11, Row A, Cell 11A
Column 11, Row A, Cell A11
Column A, Row 11, Cell A11
True
False
=E1-E2
=E2-E1
E2-E1
None of the above
File
Review
View
Formulas
Make a web page.
Write a letter
Create a poster
Record numerical data
2007
2010
2011
XP
Sorting it from highest to lowest
Finding the items that meet the criteria you indicated
Creating a filtering diagram.
Removing the items from their original place in the spreadsheet.
Spreadsheets and Workbooks
Documents
Slide Presentations
Heart Attacks and Kidney Disease
Go to the Review tab.
Sort alphabetically first.
Just sort by the information in 1 columns.
Highlight all the information in the table of the spreadsheet (except for the total and average rows or columns of information)
=avg(A4:C4)
Average(A4:C4)
=average A4 to C4
=average(A4:C4)
Do it in Word.
Click on the Review tab.
Right-click in the cell, and select Format Cells.
Click on the File tab.
Go to Insert, then Picture.
Click on the Page Layout tab, then Background.
Copy and paste the image from the Internet.
Do a screenshot.
.cels
.ppt or .pptx
.xls or .xlsx
None of the above
Record Income and Expenses
Track Inventory
Payroll
All of the Above
Pressing a button to automatically fill in the missing pieces of an image.
Isolating certain pieces of information that meet the set requirements.
Automatically filling the object with color.
The black cross you get at the bottom right of the cell so you can copy the formula to other cells
Wait!
Here's an interesting quiz for you.