Excel

How do you always start a function?

• ,

• (

• =

• SUM

Answer explanation

Formulas and functions are the same thing.

All formulas follow this pattern:

1. =

2. Name of formula

3. 3. Brackets and conditions

What cell is red?

• A1

• C1

• C4

• C5

When a student is absent, the relevant box for "Marks" has absent written in it, as shown in the picture.

If I want to know how many students gave the exam, which formula will I use?

• Count

• Substitute

• Concatenate

• Vlookup

Answer explanation

The COUNT formula counts the number of cells with numbers in them. Absent students have the word "absent" written (its a word, not a number), therefore will not be counted.

If I want to combine the text written in different cells, which formula will I use?

• Count

• Substitute

• Concatenate

• Vlookup

Answer explanation

Concatenate is used to combine the text of two or more cells.

Which of the following can be used to display the current date?

• =Today

• =Today()

• =date(A1)

• =date(A1, B1)

Answer explanation

TODAY formula displays the current date and needs no arguments (meaning the brackets are there but empty).

Recall the way formulas are written, first =, then name of the formula, then brackets and conditions/arguments.

Which of the following is the correct way to combine the first name and the last name with a space in between?

• =concatenate(A1," ",B1)

• =concatenate(A1,B1)

• =concatenate(A1, ,B1)

• =concatenate(A1" "B1)

In the Excel Chart shown, what is the place where the word "Marks" is written called?

• Chart Title

• Legend

• Data Label

• Bar

In the Excel Chart shown, key at the bottom for Math and English colors called?

• Chart Title

• Legend

• Data Label

• Bar

In the Excel Chart shown, what are the numbers written on the top of the bars called?

• Chart Title

• Legend

• Data Labels

• Barcode

Answer explanation

Data labels literally label your data. So if your bar represents 12 marks, data labels will show 12 written on top of your bar.

When printing in Excel, the following features are available:

(Select all that apply)

• Choose if you want to print current sheet or the complete workbook

• Select the print area in advance

• Preview the print

• Fit all columns on one page