D465 - DATA APPLICATIONS
QUESTIONS WITH CORRECT ANSWERS
R band bPython bsimilarities b- bcorrect banswers✔✔Both bwidely bused bin bdata bscience
bwith bextensive blibraries.
R bunique bchallenges b- bcorrect banswers✔✔Steeper blearning bcurve, blimited bweb
bdev bcapabilities.
Advantage bof bstoring bcode bin bR b- bcorrect banswers✔✔Allows breproducibility band
bcollaboration bamong banalysts.
Programming blanguages band buse bcases b- bcorrect banswers✔✔Python: bweb bdev,
bdata bscience, bML, bautomation.
MIN bfunction bin bspreadsheets b- bcorrect banswers✔✔Returns bthe bsmallest bvalue bin
ba bcell brange.
COUNTIF bfunction bin bspreadsheets b- bcorrect banswers✔✔Counts bcells bmeeting ba
bspecified bcondition.
Pivot btable belements b- bcorrect banswers✔✔Rows, bcolumns, bvalues, bfilters bfor bdata
baggregation.
SELECT bcommand bin bSQL b- bcorrect banswers✔✔Retrieves bdata bfrom bone bor
bmore bdatabase btables.
JOIN bcommands bin bSQL b- bcorrect banswers✔✔INNER, bLEFT, bRIGHT, bFULL
bOUTER bJOIN btypes.
,Delimiter bfor bcode bchunks b- bcorrect banswers✔✔Triple bbackticks bor bmarkup bto
bdefine bcode bsections.
Output bformats bfor bdocuments b- bcorrect banswers✔✔HTML, bPDF, bWord b(docx),
bMarkdown.
Presentation bformats b- bcorrect banswers✔✔Slides, bDashboards, bInteractive bweb
bapps.
Knit bbutton bin bR b- bcorrect banswers✔✔Compiles bR bMarkdown binto bdesired boutput
bformats.
Symbol bfor bcomments bin bR b- bcorrect banswers✔✔Pound bsign b(`#`) bprecedes
bcomments bin bR.
Nested bfunction busage b- bcorrect banswers✔✔Simplifies boperations, bimproves bcode
breadability.
Logical boperators b- bcorrect banswers✔✔AND b(&&), bOR b(||), bNOT b(!).
Advantage bof btidyverse b- bcorrect banswers✔✔Cohesive bdata bmanipulation bpackages
bin bR.
Functions bin bggplot2 b- bcorrect banswers✔✔ggplot(), bgeom_point(), bgeom_line(),
baes().
Plus bsign bin bggplot2 b- bcorrect banswers✔✔Adds blayers bto bggplot bobjects bfor
bcustomization.
Common berrors bin bggplot2 b- bcorrect banswers✔✔Incorrect baesthetic bmappings,
bsyntax bmisunderstanding.
Basic baesthetic battributes bin bggplot2 b- bcorrect banswers✔✔x-axis, by-axis, bcolor bfor
bplot bcustomization.
Smoothing bline busage b- bcorrect banswers✔✔Visual brepresentation bof btrends bin
bdata.
dplyr bfilter() bfunction b- bcorrect banswers✔✔Subset brows bbased bon bspecific
bconditions bin bR.
VLOOKUP bfunction bin bspreadsheets b- bcorrect banswers✔✔Searches bfor bvalues bin
ba bvertical bcolumn.
Locking btable barray bin bVLOOKUP b- bcorrect banswers✔✔Prevents brange bchanges
bfor bformula baccuracy.
, Different bJOIN bfunctions bin bSQL b- bcorrect banswers✔✔INNER, bLEFT, bRIGHT,
bFULL bOUTER bJOIN btypes.
COUNT bvs. bCOUNT bDISTINCT bin bSQL b- bcorrect banswers✔✔COUNT: btotal brows,
bCOUNT bDISTINCT: bunique bvalues.
SELECT bstatement busage bin bSQL b- bcorrect banswers✔✔Retrieving bdata bfrom bone
bor bmore btables.
FROM bstatement bin bSQL b- bcorrect banswers✔✔Specifies btables bfor bdata bretrieval
bin bSQL bqueries.
Tibbles bvs. bdata bframes b- bcorrect banswers✔✔Modernized bdata bframes bwith
bimproved bfeatures.
Main boperators bin bR b- bcorrect banswers✔✔Arithmetic, brelational, blogical, bassignment
boperators.
sample() bfunction bfor bbiased bdata b- bcorrect banswers✔✔Creates brandom bunbiased
bdata bsamples.
Fill bin bthe bblank: bThe bspreadsheet bfunction b_____ breturns bthe bnumber bof bcells
bwithin ba brange bthat bmatch ba bspecified bvalue.
COUNTIF
ARRAY
COUNT bDISTINCT
VALUE b- bcorrect banswers✔✔COUNTIF
What bis ban bexample bof ban barray bin ba bspreadsheet?
All bcells bwith bnumber bvalues
Cells bD7, bE14, band bF20
The bvalues bin bcells bB2 bthrough bB31
All bcells bwith bvalues bgreater bthan b100 b- bcorrect banswers✔✔The bvalues bin bcells
bB2 bthrough bB31
Which bfunction bwill bcalculate bthe bsum bof bthe bproducts bof bthe bcorresponding bitems
bin bthe barrays bM1:M4 band bP1:P4?
=SUMPRODUCT(M1:M4, bP1:P4)
=MULTIPLY(M1:M4, bP1:P4)
=PRODUCT(M1:M4, bP1:P4)
=ARRAY(M1:M4, bP1:P4) b- bcorrect banswers✔✔=SUMPRODUCT(M1:M4, bP1:P4)
QUESTIONS WITH CORRECT ANSWERS
R band bPython bsimilarities b- bcorrect banswers✔✔Both bwidely bused bin bdata bscience
bwith bextensive blibraries.
R bunique bchallenges b- bcorrect banswers✔✔Steeper blearning bcurve, blimited bweb
bdev bcapabilities.
Advantage bof bstoring bcode bin bR b- bcorrect banswers✔✔Allows breproducibility band
bcollaboration bamong banalysts.
Programming blanguages band buse bcases b- bcorrect banswers✔✔Python: bweb bdev,
bdata bscience, bML, bautomation.
MIN bfunction bin bspreadsheets b- bcorrect banswers✔✔Returns bthe bsmallest bvalue bin
ba bcell brange.
COUNTIF bfunction bin bspreadsheets b- bcorrect banswers✔✔Counts bcells bmeeting ba
bspecified bcondition.
Pivot btable belements b- bcorrect banswers✔✔Rows, bcolumns, bvalues, bfilters bfor bdata
baggregation.
SELECT bcommand bin bSQL b- bcorrect banswers✔✔Retrieves bdata bfrom bone bor
bmore bdatabase btables.
JOIN bcommands bin bSQL b- bcorrect banswers✔✔INNER, bLEFT, bRIGHT, bFULL
bOUTER bJOIN btypes.
,Delimiter bfor bcode bchunks b- bcorrect banswers✔✔Triple bbackticks bor bmarkup bto
bdefine bcode bsections.
Output bformats bfor bdocuments b- bcorrect banswers✔✔HTML, bPDF, bWord b(docx),
bMarkdown.
Presentation bformats b- bcorrect banswers✔✔Slides, bDashboards, bInteractive bweb
bapps.
Knit bbutton bin bR b- bcorrect banswers✔✔Compiles bR bMarkdown binto bdesired boutput
bformats.
Symbol bfor bcomments bin bR b- bcorrect banswers✔✔Pound bsign b(`#`) bprecedes
bcomments bin bR.
Nested bfunction busage b- bcorrect banswers✔✔Simplifies boperations, bimproves bcode
breadability.
Logical boperators b- bcorrect banswers✔✔AND b(&&), bOR b(||), bNOT b(!).
Advantage bof btidyverse b- bcorrect banswers✔✔Cohesive bdata bmanipulation bpackages
bin bR.
Functions bin bggplot2 b- bcorrect banswers✔✔ggplot(), bgeom_point(), bgeom_line(),
baes().
Plus bsign bin bggplot2 b- bcorrect banswers✔✔Adds blayers bto bggplot bobjects bfor
bcustomization.
Common berrors bin bggplot2 b- bcorrect banswers✔✔Incorrect baesthetic bmappings,
bsyntax bmisunderstanding.
Basic baesthetic battributes bin bggplot2 b- bcorrect banswers✔✔x-axis, by-axis, bcolor bfor
bplot bcustomization.
Smoothing bline busage b- bcorrect banswers✔✔Visual brepresentation bof btrends bin
bdata.
dplyr bfilter() bfunction b- bcorrect banswers✔✔Subset brows bbased bon bspecific
bconditions bin bR.
VLOOKUP bfunction bin bspreadsheets b- bcorrect banswers✔✔Searches bfor bvalues bin
ba bvertical bcolumn.
Locking btable barray bin bVLOOKUP b- bcorrect banswers✔✔Prevents brange bchanges
bfor bformula baccuracy.
, Different bJOIN bfunctions bin bSQL b- bcorrect banswers✔✔INNER, bLEFT, bRIGHT,
bFULL bOUTER bJOIN btypes.
COUNT bvs. bCOUNT bDISTINCT bin bSQL b- bcorrect banswers✔✔COUNT: btotal brows,
bCOUNT bDISTINCT: bunique bvalues.
SELECT bstatement busage bin bSQL b- bcorrect banswers✔✔Retrieving bdata bfrom bone
bor bmore btables.
FROM bstatement bin bSQL b- bcorrect banswers✔✔Specifies btables bfor bdata bretrieval
bin bSQL bqueries.
Tibbles bvs. bdata bframes b- bcorrect banswers✔✔Modernized bdata bframes bwith
bimproved bfeatures.
Main boperators bin bR b- bcorrect banswers✔✔Arithmetic, brelational, blogical, bassignment
boperators.
sample() bfunction bfor bbiased bdata b- bcorrect banswers✔✔Creates brandom bunbiased
bdata bsamples.
Fill bin bthe bblank: bThe bspreadsheet bfunction b_____ breturns bthe bnumber bof bcells
bwithin ba brange bthat bmatch ba bspecified bvalue.
COUNTIF
ARRAY
COUNT bDISTINCT
VALUE b- bcorrect banswers✔✔COUNTIF
What bis ban bexample bof ban barray bin ba bspreadsheet?
All bcells bwith bnumber bvalues
Cells bD7, bE14, band bF20
The bvalues bin bcells bB2 bthrough bB31
All bcells bwith bvalues bgreater bthan b100 b- bcorrect banswers✔✔The bvalues bin bcells
bB2 bthrough bB31
Which bfunction bwill bcalculate bthe bsum bof bthe bproducts bof bthe bcorresponding bitems
bin bthe barrays bM1:M4 band bP1:P4?
=SUMPRODUCT(M1:M4, bP1:P4)
=MULTIPLY(M1:M4, bP1:P4)
=PRODUCT(M1:M4, bP1:P4)
=ARRAY(M1:M4, bP1:P4) b- bcorrect banswers✔✔=SUMPRODUCT(M1:M4, bP1:P4)
