SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 2 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Engineering Posted 11 Oct 2017 My Price 9.00

In order to get to the bottom of the dataset in Excel, press:

QUESTION 1

  1. In order to get to the bottom of the dataset in Excel, press:
  2. Ctrl + Down Arrow
  3. Ctrl + Up Arrow
  4. Ctrl + Shift + Down Arrow
  5. Ctrl + Shift + Up Arrow
  6. Ctrl + Alt + Down Arrow

10 points  

QUESTION 2

  1. You entered a formula into cell A4, in order to undo this action (remove the formula from cell A4) in Excel, press:
  2. Ctrl + A
  3. Ctrl + B
  4. Ctrl + C
  5. Ctrl + V
  6. Ctrl + Z

10 points  

QUESTION 3

  1. In order to invoke the "Help" in an Excel worksheet, press:
  2. F1
  3. F3
  4. F4
  5. F5
  6. F9

10 points  

QUESTION 4

  1. After changing the number format of cell B2 to "Currency", number 10 in cell B2 appears as:
  2. 10.00
  3. $10.00
  4. 10.00%
  5. 1/10/1900
  6. 1000%

10 points  

QUESTION 5

  1. The cell B2 is being used in formulas in other cells. In order to lock the reference to cell B2, use the following key:
  2. F1
  3. F4
  4. F9
  5. Ctrl C
  6. Ctrl V

10 points  

QUESTION 6

  1. In Excel, to create a random number between 0 and 10 use the following function:
  2. =RAND()
  3. =RANDOM(0,10)
  4. =RANDBETWEEN(0,10)
  5. F1
  6. F4

10 points  

QUESTION 7

  1. To change the order of values in a range of cells from minimum to maximum:
  2. use number formatting
  3. use Sort
  4. use Filter
  5. use Pivot Table
  6. use F4

10 points  

QUESTION 8

  1. To compares values across categories, use:
  2. bubble chart
  3. column chart
  4. line chart
  5. scatter plot
  6. table chart

10 points  

QUESTION 9

  1. The number 1.9E-19 appears in a cell. Which one of the following statements is correct?
  2. the actual number is -19.19
  3. the actual number is approximately 0
  4. the actual number is 0.19
  5. the actual number is 1.9
  6. there is a calculation error in the cell

10 points  

QUESTION 10

  1. You wish to calculate the square root of the value in cell D4 in an Excel spreadsheet. Which of the following would NOT give the correct answer?
  2. =D4^(1/2)
  3. =SQRT(D4)
  4. =ROOT(D4)
  5. =D4^0.5
  6. =EXP(LN(D4)/2

 

Answers

SophiaPretty
(5)
Status NEW Posted 11 Oct 2017 11:10 AM My Price 9.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)