Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
10 Cards in this Set
- Front
- Back
count number of values in a row that are greater than 2000
|
=COUNTIF(B3:B9,">2000")
|
|
create custom number format
|
numbers (expand), click on custom
|
|
delete comments in a number of cells
|
review tab, highlight cells,
|
|
different types of tables
|
(grid), select table, click on format as a table
|
|
multiply a cell by an absolute reference to input a different number
|
=($B$5) will continually reference b5 when the formula is copied to different squares
|
|
check compatibility when saving
|
office logo, prepare, check compatibility
|
|
count number of cells in a range that arent empty
|
countA(b:2:b4)
|
|
insert function to total the total product values in c7:c22 of beverages, only if beverages are in the range of a7:a22
|
=sumsif(a7:a22, "beverages", f7:f22)
|
|
subtotal the data in cell range b4:b20, average the totals. and put page breaks in between them
|
highlight table, data tab, subtotal, select criteria (average by sum), check box on bottom for page break.
|
|
rotated verticle axis to chart
|
make chart, chart layout tab, axis title, primary vertical, rotated
|