Exam 1

Question 1

Are row headings on excel found on the left of the worksheet?

Answer 1

Yes

Question 2

Where is the status bar found and what does it contain?

Answer 2

Has the zoom button and view button and can be found at the bottom of the workbook

Question 3

What two functions is the tell me box used for?

Answer 3

Find command and office help system

Question 4

What can the ribbon display option button do?

Answer 4

Minimise and maximise the ribbon

Question 5

What three things is excel mostly used for?

Answer 5

Record, analyse, and present

Question 6

Roughly how many rows and columns does excel have?

Answer 6

Over a million rows and around 16,000 columns

Question 7

Is ScreenTip shown to either provide info or help?

Answer 7

Yes

Question 8

What is classified as text string?

Answer 8

Letters, numbers, and symbols

Question 9

What does autocomplete try to do?

Answer 9

Predict what will be inserted into the rest of the column

Question 10

How can multiple column widths and row heights be changed from their normal 64 and 20 pixels respectively?

Answer 10

By clicking on the first and then pressing shift and clicking on the last heading

Question 11

What are two ways to write effective formulas?

Answer 11

Don’t hide data values and break up formulas to show intermediate results

Question 12

What is the COUNT function used to do?

Answer 12

Determine how many non-empty cells there are

Question 13

What is the difference between pasting and moving range?

Answer 13

Moving you don’t need to press CTRL but pasting you do. Or can paste by copying the cell then clicking new cell or the upper left cell of the range

Question 14

To delete or insert row do you need to go to cells group on ribbon?

Answer 14

Yes