A
How is a cell in excel identified?
Letter Number example D3
Count
To count the cells even if they are empty.
=Count(A11:A29)
What is Replace used for?
To replace content of the cells.
How can you add picture on the background?
Page layout-Background-Picture
What is excel?
Collection of rows and columns
CountA
count cells which are not empty
How can we identify with colors if the content of some cells fullfill a condition?
By conditional formatting
Clear Formats
Clear formatting but not deleting the contents
How can you convert 3 to 3%?
Using percentage format
How is a row identified?
Number
How can you calculate the average of the numbers that are at Cell C10 to C15?
=Average(C10:C15)
What are margins?
The white space at the side of the document
How can you use themes?
Page layout, on the left click themes
Which is that icon that helps you to merge two or more cells in one cell?
Merge¢er
How is a column identified?
Letter
=Sum(E4:11)
sum values from e4 to e11
Now()
Function that displays the date and time.
What is the difference between theme color and standard color?
Standard colors are fixed.
What is comma , used on large numbers for?
To distinguish 000
Sum
To sum the values of multiple cells
How do we create layout breaks?
Page layout-Breaks-Insert Page Breaks
What is the difference between accounting and currency?
Accounting uses the $ far left from the number.
What is decimal places used for?
To assign numbers after the . of a number.
Rename Sheet
Format-Rename Sheet