390 likes | 1.09k Views
Intermediate Excel. “Review & Preview of Skills” Correct Answers on Slide 12. The “fat” plus cursor is used to:. Highlight (select) cells. Move the contents of a cell to another cell. Fill cell contents into cells below or to right. The “skinny” plus cursor is used to:.
E N D
Intermediate Excel “Review & Preview of Skills” Correct Answers on Slide 12
The “fat” plus cursor is used to: • Highlight (select) cells. • Move the contents of a cell to another cell. • Fill cell contents into cells below or to right.
The “skinny” plus cursor is used to: • Highlight (select cells) • Move the contents of a cell to another cell. • Fill cell contents into cells below or to the right.
The “4-headed arrow” cursor is used to: • Highlight (select cells) • Move the contents of a cell to another cell. • Fill cell contents into cells below or to the right.
To rename a worksheet: • Double-click Worksheet tab, type new name. • Right click, Rename, type new name. • Both 1. & 2. are correct.
To insert a function, click on: • fx on formula bar. • Insert, Function • Both 1. and 2. are correct.
To create a copy of a worksheet to the same workbook or into a new or different workbook, do which of the following: • Right click on worksheet tab and choose Moveor Copy. • File, Save as • File, Save
Excel allows you to quickly find the total of a column or row by: • Using Max function. • Using CountIf function. • Using AutoSum Σ function.
Excel allows you to quickly find the average of a set of numbers by: • Using Max function. • Using CountIf function. • Using Average function.
To count cells within a range that meet a given criteria, use: • Count function. • CountIf function. • CountA function.
To undo or redo an action in a cell, click on the Menu bar item labeled: • Edit, Undo • Help, Undo • Data, Undo
Correct Answers • The “fat” plus cursor is used to Highlight (select) cells. • The “skinny” plus cursor is used to fill cell contents into cells below or to the right. • The “4-headed arrow” cursor is used to move the contents of a cell to another cell. • To rename a worksheet both 1 and 2 are correct: Double-click worksheet tab, type new name or Right-click, Rename, and type new name. • To insert a function, click on: (Both 1. and 2. are correct.) fx on formula bar or Insert, Function. • To create a copy of a worksheet to the same workbook or into a new or different workbook, right click on worksheet tab and choose Move or Copy. • Excel allows you to quickly find the total of a column or row by using AutoSum Σ function. • Excel allows you to quickly find the average of a set of numbers by Using Average function. • To count cells within a range that meet a given criteria, use CountIf function. • To undo or redo an action in a cell, click on the Menu bar item labeled Edit, Undo.