Excel basics Flashcards
1
Q
function for standard deviation
A
=STDEV()
2
Q
what is the keyboard shortcut to select every cell in the Excel Worksheet?
A
Ctrl A
3
Q
what is the keyboard shortcut to undo the function?
A
Ctrl Z
4
Q
What is the keyboard shortcut to copy the selected cells
A
Ctrl C
5
Q
What is the keyboard shortcut to paste the copied cells.
A
Ctrl V
6
Q
What is the function to count the number of cells that contains numbers?
A
=COUNT()
7
Q
What is the keyboard shortcut for counts based on multiple criteria?
A
=COUNTIFS()
8
Q
What is the keyboard shortcut for sum cells based on 1 criteria?
A
=SUMIF()
9
Q
What is the keyboard shortcut for sum cells based on multiple criteria?
A
=SUMIFS()
10
Q
What is the keyboard shortcut for sum cells based on 2 criteria?
A
=SUMIF()
