Font size
WorksheetsYANEQ
Total questions: 22
Worksheet time: 12mins
You can make graphs or charts on Microsoft Excel even without the data.
TRUE
FALSE
If you want to highlight all rows and columns in one go, you can use (Ctrl + A) held together.
TRUE
FALSE
What is the name of this chart?
COLUMN
BAR
LINE
PIE
What is the name of this chart?
COLUMN
BAR
LINE
PIE
What is the name of this chart?
COLUMN
BAR
LINE
PIE
Which one is NOT the way to fill the total?
CLICK insert function > choose CELL then Enter
click (Shift+F3) > choose cell then Enter
click formula > autosum then click enter
click CTRL+A
Which one is the symbol of autosum?
Formula is a mathematical expression for calculating/computing. in excel wich one the formula to fill the picture?
Who is the maker of Excel?
Windows
Excel
Microsoft
Mac
What kind of software is Excel?
Word processing Software
Spreadsheet Software
Database Software
Presentation Software
Excel refers to files as
Documents
Workbooks
Databases
Files
What kind of chart should you use to show the pieces (percentages) of a whole?
Bar Chart
Column Chart
Pie Chart
In Excel, the cell C3 contains the formula =A3/B3. If I copy this and paste it into the cell D5, what will the formula for cell D5 be?
=A3/B3
=C3
=A5/B5
=B5/C5
In Excel, the cell C3 contains the formula =$A3/$B3. If I copy this and paste it into the cell D5, what will the formula for cell D5 be?
=$A3/$B3
=$C3
=$A5/$B5
=$B5/$C5
In Excel, if the cell C3 contains the formula =$A$3/$B$3 and I copy this and paste it into the cell D5, what will the formula for cell D5 be?
=$A$3/$B$3
=$C$3
=$A$5/$B$5
=$B$5/$C$5
Looking at the image, using a formula, what would the contents of E4 be?
(a)
Looking at the image, which formula would E6 have?
B6+C6+D6
=ADD(B6:D6)
=SUM(B6:D6)
=TOTAL(B6:D6)
Looking at the image, using a formula, how would you calculate the average of the cell range B5 to D5?
(a)
What will clicking on Filter do?
It will sort the data in alphabetical order
It will hide the rows that meet a certain criteria
It will find the first row that contains the data
It will only show the rows that meet a certain criteria
What will clicking on Sort A to Z do?
It will sort the data in alphabetical order
It will hide the rows that meet a certain criteria
It will find the first row that contains the data
It will only show the rows that meet a certain criteria
