• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/10

Click to flip

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